Line and clustered column Visual 15

Visual 1: Line and clustered column Visual >> Deaths Per Mth, %MoM, %/YoY by Month

For gif Step1

Fields Tab

·         Shared Axis: Month/Year/Quarter

·         Column Values: Deaths Per Mth

·         Line Values: %MoM, %YoY

Format Tab

·         General: X Position = 231, Y Position = 91, Width = 515, Height 310

·          

For gif Step2

·         Legend: On, Position = Top, Title = off, Color = #00000, font family = Segoe UI, Text size = 10, Style = Markers Only, Match line color = on, Circle default icon = on

·         X Axis: Color = #00000, Text Size = 9, Font family = Segoe UI, Minimum category width = 20, Maximum Size = 25%, Inner Padding = 15%, Concatenate labels = On, Title = off

·         Y Axis: Position = Left, Scale Type = Linear, start = Auto, End = Auto, Invert axis= off, Color = #00000, Text size = 10, Font family = Segoe UI, Display Units = Auto, Value decimal Places= Auto, Title = off, Gridlines = on, Line color = #CCCCC, Strock width = 2, Line Style = Dotted, show secondary = On, Align zeros = on

·         Zoom Slider = off,

·         Data Colors, %MoM = #33DBFF, YoY% = #ECC846, Default Color = #00000, Show all = off

·          Data Label = On, Color = #FFFFF, Display Units = Auto, Value Decimal places = Auto, Orientation = Horizontal, Position = Auto, Text Size = 10, Font Family = DIN, Show Background = On, Background Color = #FFFFFF, Transparency = 100%, Customize series = off

·         Shapes: Shade area = On, Stroke width = 2, Join Type = Round, Line Style = Solid, show marker = on, Marker shape =., Meaker Size = 5, Marker color = #FFFFF, stepped = off, customize series = on, %MoM, Shade area = on, Stroke width = 2, Join type = round, Line style = Solid, show marker = on, Marker size = 5, Marker color = #ECC846, Stepped = off

·         Plot area Transparency = 0%

 

For gif Step 3

·         Title = On, Title Text = By Month, Title heading = Heading 3, Word wrap = On, font color = #FFFFF, Background color = #00000, Alignment = Center, Text Size = 14, Font Family = Segoe UI  

·         Background: On, color = #FFFFF, Transparency = 0

·         Lock aspect = off

·         Border:  = off

·         Shadow: = off

·         Tooltip = On, Type = Report Page, Page = Auto, Label Text color = #C8C8C8, Value text color = #EAEAEA, Text size = 9, Font family = Segoe UI, Background color = #00000, Transparency = 5%

·         Visual header = On, background color = #FFFFFF, Boarder = #FFFFFF, Transparency = 0%, Icon color = #00000, Visual information icon = On, Visual warning icon = On, Visual error icon = on, Drill on drop down = On, drill up icon = On, Drill down icon = On, show next level icon = On, Expand to next level icon = On, Pin icon = On, Focus mode icon = On, Filter icon = On, See data layout icon = On, More Options icon = On, Visua headre tooltip icon = off

Use the following step by step Gif to create the visual


Step 1



Step 2


Step 3


How to create line and clustered column chart in power bi

https://www.youtube.com/watch?v=2d1JhcrhhGo